package com.desksoft.ecommerce.entity.mall.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class FavoriteExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public FavoriteExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNull() {
            addCriterion("CardNo is null");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNotNull() {
            addCriterion("CardNo is not null");
            return (Criteria) this;
        }

        public Criteria andCardnoEqualTo(String value) {
            addCriterion("CardNo =", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotEqualTo(String value) {
            addCriterion("CardNo <>", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThan(String value) {
            addCriterion("CardNo >", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThanOrEqualTo(String value) {
            addCriterion("CardNo >=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThan(String value) {
            addCriterion("CardNo <", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThanOrEqualTo(String value) {
            addCriterion("CardNo <=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLike(String value) {
            addCriterion("CardNo like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotLike(String value) {
            addCriterion("CardNo not like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoIn(List<String> values) {
            addCriterion("CardNo in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotIn(List<String> values) {
            addCriterion("CardNo not in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoBetween(String value1, String value2) {
            addCriterion("CardNo between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotBetween(String value1, String value2) {
            addCriterion("CardNo not between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNull() {
            addCriterion("ItemCode is null");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNotNull() {
            addCriterion("ItemCode is not null");
            return (Criteria) this;
        }

        public Criteria andItemcodeEqualTo(String value) {
            addCriterion("ItemCode =", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotEqualTo(String value) {
            addCriterion("ItemCode <>", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThan(String value) {
            addCriterion("ItemCode >", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ItemCode >=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThan(String value) {
            addCriterion("ItemCode <", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThanOrEqualTo(String value) {
            addCriterion("ItemCode <=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLike(String value) {
            addCriterion("ItemCode like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotLike(String value) {
            addCriterion("ItemCode not like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeIn(List<String> values) {
            addCriterion("ItemCode in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotIn(List<String> values) {
            addCriterion("ItemCode not in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeBetween(String value1, String value2) {
            addCriterion("ItemCode between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotBetween(String value1, String value2) {
            addCriterion("ItemCode not between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andQtyIsNull() {
            addCriterion("Qty is null");
            return (Criteria) this;
        }

        public Criteria andQtyIsNotNull() {
            addCriterion("Qty is not null");
            return (Criteria) this;
        }

        public Criteria andQtyEqualTo(BigDecimal value) {
            addCriterion("Qty =", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotEqualTo(BigDecimal value) {
            addCriterion("Qty <>", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThan(BigDecimal value) {
            addCriterion("Qty >", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty >=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThan(BigDecimal value) {
            addCriterion("Qty <", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty <=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyIn(List<BigDecimal> values) {
            addCriterion("Qty in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotIn(List<BigDecimal> values) {
            addCriterion("Qty not in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty not between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andApplytimeIsNull() {
            addCriterion("ApplyTime is null");
            return (Criteria) this;
        }

        public Criteria andApplytimeIsNotNull() {
            addCriterion("ApplyTime is not null");
            return (Criteria) this;
        }

        public Criteria andApplytimeEqualTo(Date value) {
            addCriterion("ApplyTime =", value, "applytime");
            return (Criteria) this;
        }

        public Criteria andApplytimeNotEqualTo(Date value) {
            addCriterion("ApplyTime <>", value, "applytime");
            return (Criteria) this;
        }

        public Criteria andApplytimeGreaterThan(Date value) {
            addCriterion("ApplyTime >", value, "applytime");
            return (Criteria) this;
        }

        public Criteria andApplytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ApplyTime >=", value, "applytime");
            return (Criteria) this;
        }

        public Criteria andApplytimeLessThan(Date value) {
            addCriterion("ApplyTime <", value, "applytime");
            return (Criteria) this;
        }

        public Criteria andApplytimeLessThanOrEqualTo(Date value) {
            addCriterion("ApplyTime <=", value, "applytime");
            return (Criteria) this;
        }

        public Criteria andApplytimeIn(List<Date> values) {
            addCriterion("ApplyTime in", values, "applytime");
            return (Criteria) this;
        }

        public Criteria andApplytimeNotIn(List<Date> values) {
            addCriterion("ApplyTime not in", values, "applytime");
            return (Criteria) this;
        }

        public Criteria andApplytimeBetween(Date value1, Date value2) {
            addCriterion("ApplyTime between", value1, value2, "applytime");
            return (Criteria) this;
        }

        public Criteria andApplytimeNotBetween(Date value1, Date value2) {
            addCriterion("ApplyTime not between", value1, value2, "applytime");
            return (Criteria) this;
        }

        public Criteria andOldflagIsNull() {
            addCriterion("OldFlag is null");
            return (Criteria) this;
        }

        public Criteria andOldflagIsNotNull() {
            addCriterion("OldFlag is not null");
            return (Criteria) this;
        }

        public Criteria andOldflagEqualTo(String value) {
            addCriterion("OldFlag =", value, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagNotEqualTo(String value) {
            addCriterion("OldFlag <>", value, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagGreaterThan(String value) {
            addCriterion("OldFlag >", value, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagGreaterThanOrEqualTo(String value) {
            addCriterion("OldFlag >=", value, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagLessThan(String value) {
            addCriterion("OldFlag <", value, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagLessThanOrEqualTo(String value) {
            addCriterion("OldFlag <=", value, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagLike(String value) {
            addCriterion("OldFlag like", value, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagNotLike(String value) {
            addCriterion("OldFlag not like", value, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagIn(List<String> values) {
            addCriterion("OldFlag in", values, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagNotIn(List<String> values) {
            addCriterion("OldFlag not in", values, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagBetween(String value1, String value2) {
            addCriterion("OldFlag between", value1, value2, "oldflag");
            return (Criteria) this;
        }

        public Criteria andOldflagNotBetween(String value1, String value2) {
            addCriterion("OldFlag not between", value1, value2, "oldflag");
            return (Criteria) this;
        }

        public Criteria andFavflagIsNull() {
            addCriterion("FavFlag is null");
            return (Criteria) this;
        }

        public Criteria andFavflagIsNotNull() {
            addCriterion("FavFlag is not null");
            return (Criteria) this;
        }

        public Criteria andFavflagEqualTo(String value) {
            addCriterion("FavFlag =", value, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagNotEqualTo(String value) {
            addCriterion("FavFlag <>", value, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagGreaterThan(String value) {
            addCriterion("FavFlag >", value, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagGreaterThanOrEqualTo(String value) {
            addCriterion("FavFlag >=", value, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagLessThan(String value) {
            addCriterion("FavFlag <", value, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagLessThanOrEqualTo(String value) {
            addCriterion("FavFlag <=", value, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagLike(String value) {
            addCriterion("FavFlag like", value, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagNotLike(String value) {
            addCriterion("FavFlag not like", value, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagIn(List<String> values) {
            addCriterion("FavFlag in", values, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagNotIn(List<String> values) {
            addCriterion("FavFlag not in", values, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagBetween(String value1, String value2) {
            addCriterion("FavFlag between", value1, value2, "favflag");
            return (Criteria) this;
        }

        public Criteria andFavflagNotBetween(String value1, String value2) {
            addCriterion("FavFlag not between", value1, value2, "favflag");
            return (Criteria) this;
        }

        public Criteria andCategoryIsNull() {
            addCriterion("Category is null");
            return (Criteria) this;
        }

        public Criteria andCategoryIsNotNull() {
            addCriterion("Category is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryEqualTo(String value) {
            addCriterion("Category =", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotEqualTo(String value) {
            addCriterion("Category <>", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryGreaterThan(String value) {
            addCriterion("Category >", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryGreaterThanOrEqualTo(String value) {
            addCriterion("Category >=", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryLessThan(String value) {
            addCriterion("Category <", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryLessThanOrEqualTo(String value) {
            addCriterion("Category <=", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryLike(String value) {
            addCriterion("Category like", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotLike(String value) {
            addCriterion("Category not like", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryIn(List<String> values) {
            addCriterion("Category in", values, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotIn(List<String> values) {
            addCriterion("Category not in", values, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryBetween(String value1, String value2) {
            addCriterion("Category between", value1, value2, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotBetween(String value1, String value2) {
            addCriterion("Category not between", value1, value2, "category");
            return (Criteria) this;
        }

        public Criteria andBrandIsNull() {
            addCriterion("Brand is null");
            return (Criteria) this;
        }

        public Criteria andBrandIsNotNull() {
            addCriterion("Brand is not null");
            return (Criteria) this;
        }

        public Criteria andBrandEqualTo(String value) {
            addCriterion("Brand =", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotEqualTo(String value) {
            addCriterion("Brand <>", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandGreaterThan(String value) {
            addCriterion("Brand >", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandGreaterThanOrEqualTo(String value) {
            addCriterion("Brand >=", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandLessThan(String value) {
            addCriterion("Brand <", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandLessThanOrEqualTo(String value) {
            addCriterion("Brand <=", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandLike(String value) {
            addCriterion("Brand like", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotLike(String value) {
            addCriterion("Brand not like", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandIn(List<String> values) {
            addCriterion("Brand in", values, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotIn(List<String> values) {
            addCriterion("Brand not in", values, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandBetween(String value1, String value2) {
            addCriterion("Brand between", value1, value2, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotBetween(String value1, String value2) {
            addCriterion("Brand not between", value1, value2, "brand");
            return (Criteria) this;
        }

        public Criteria andCategorydIsNull() {
            addCriterion("CategoryD is null");
            return (Criteria) this;
        }

        public Criteria andCategorydIsNotNull() {
            addCriterion("CategoryD is not null");
            return (Criteria) this;
        }

        public Criteria andCategorydEqualTo(String value) {
            addCriterion("CategoryD =", value, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydNotEqualTo(String value) {
            addCriterion("CategoryD <>", value, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydGreaterThan(String value) {
            addCriterion("CategoryD >", value, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydGreaterThanOrEqualTo(String value) {
            addCriterion("CategoryD >=", value, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydLessThan(String value) {
            addCriterion("CategoryD <", value, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydLessThanOrEqualTo(String value) {
            addCriterion("CategoryD <=", value, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydLike(String value) {
            addCriterion("CategoryD like", value, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydNotLike(String value) {
            addCriterion("CategoryD not like", value, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydIn(List<String> values) {
            addCriterion("CategoryD in", values, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydNotIn(List<String> values) {
            addCriterion("CategoryD not in", values, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydBetween(String value1, String value2) {
            addCriterion("CategoryD between", value1, value2, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategorydNotBetween(String value1, String value2) {
            addCriterion("CategoryD not between", value1, value2, "categoryd");
            return (Criteria) this;
        }

        public Criteria andCategoryzIsNull() {
            addCriterion("CategoryZ is null");
            return (Criteria) this;
        }

        public Criteria andCategoryzIsNotNull() {
            addCriterion("CategoryZ is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryzEqualTo(String value) {
            addCriterion("CategoryZ =", value, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzNotEqualTo(String value) {
            addCriterion("CategoryZ <>", value, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzGreaterThan(String value) {
            addCriterion("CategoryZ >", value, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzGreaterThanOrEqualTo(String value) {
            addCriterion("CategoryZ >=", value, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzLessThan(String value) {
            addCriterion("CategoryZ <", value, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzLessThanOrEqualTo(String value) {
            addCriterion("CategoryZ <=", value, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzLike(String value) {
            addCriterion("CategoryZ like", value, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzNotLike(String value) {
            addCriterion("CategoryZ not like", value, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzIn(List<String> values) {
            addCriterion("CategoryZ in", values, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzNotIn(List<String> values) {
            addCriterion("CategoryZ not in", values, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzBetween(String value1, String value2) {
            addCriterion("CategoryZ between", value1, value2, "categoryz");
            return (Criteria) this;
        }

        public Criteria andCategoryzNotBetween(String value1, String value2) {
            addCriterion("CategoryZ not between", value1, value2, "categoryz");
            return (Criteria) this;
        }

        public Criteria andUsertypeIsNull() {
            addCriterion("UserType is null");
            return (Criteria) this;
        }

        public Criteria andUsertypeIsNotNull() {
            addCriterion("UserType is not null");
            return (Criteria) this;
        }

        public Criteria andUsertypeEqualTo(String value) {
            addCriterion("UserType =", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotEqualTo(String value) {
            addCriterion("UserType <>", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeGreaterThan(String value) {
            addCriterion("UserType >", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeGreaterThanOrEqualTo(String value) {
            addCriterion("UserType >=", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLessThan(String value) {
            addCriterion("UserType <", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLessThanOrEqualTo(String value) {
            addCriterion("UserType <=", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLike(String value) {
            addCriterion("UserType like", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotLike(String value) {
            addCriterion("UserType not like", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeIn(List<String> values) {
            addCriterion("UserType in", values, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotIn(List<String> values) {
            addCriterion("UserType not in", values, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeBetween(String value1, String value2) {
            addCriterion("UserType between", value1, value2, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotBetween(String value1, String value2) {
            addCriterion("UserType not between", value1, value2, "usertype");
            return (Criteria) this;
        }

        public Criteria andFavtypeIsNull() {
            addCriterion("FavType is null");
            return (Criteria) this;
        }

        public Criteria andFavtypeIsNotNull() {
            addCriterion("FavType is not null");
            return (Criteria) this;
        }

        public Criteria andFavtypeEqualTo(String value) {
            addCriterion("FavType =", value, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeNotEqualTo(String value) {
            addCriterion("FavType <>", value, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeGreaterThan(String value) {
            addCriterion("FavType >", value, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeGreaterThanOrEqualTo(String value) {
            addCriterion("FavType >=", value, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeLessThan(String value) {
            addCriterion("FavType <", value, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeLessThanOrEqualTo(String value) {
            addCriterion("FavType <=", value, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeLike(String value) {
            addCriterion("FavType like", value, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeNotLike(String value) {
            addCriterion("FavType not like", value, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeIn(List<String> values) {
            addCriterion("FavType in", values, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeNotIn(List<String> values) {
            addCriterion("FavType not in", values, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeBetween(String value1, String value2) {
            addCriterion("FavType between", value1, value2, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavtypeNotBetween(String value1, String value2) {
            addCriterion("FavType not between", value1, value2, "favtype");
            return (Criteria) this;
        }

        public Criteria andFavcodeIsNull() {
            addCriterion("FavCode is null");
            return (Criteria) this;
        }

        public Criteria andFavcodeIsNotNull() {
            addCriterion("FavCode is not null");
            return (Criteria) this;
        }

        public Criteria andFavcodeEqualTo(String value) {
            addCriterion("FavCode =", value, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeNotEqualTo(String value) {
            addCriterion("FavCode <>", value, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeGreaterThan(String value) {
            addCriterion("FavCode >", value, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeGreaterThanOrEqualTo(String value) {
            addCriterion("FavCode >=", value, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeLessThan(String value) {
            addCriterion("FavCode <", value, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeLessThanOrEqualTo(String value) {
            addCriterion("FavCode <=", value, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeLike(String value) {
            addCriterion("FavCode like", value, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeNotLike(String value) {
            addCriterion("FavCode not like", value, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeIn(List<String> values) {
            addCriterion("FavCode in", values, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeNotIn(List<String> values) {
            addCriterion("FavCode not in", values, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeBetween(String value1, String value2) {
            addCriterion("FavCode between", value1, value2, "favcode");
            return (Criteria) this;
        }

        public Criteria andFavcodeNotBetween(String value1, String value2) {
            addCriterion("FavCode not between", value1, value2, "favcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIsNull() {
            addCriterion("VendorCode is null");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIsNotNull() {
            addCriterion("VendorCode is not null");
            return (Criteria) this;
        }

        public Criteria andVendorcodeEqualTo(String value) {
            addCriterion("VendorCode =", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotEqualTo(String value) {
            addCriterion("VendorCode <>", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeGreaterThan(String value) {
            addCriterion("VendorCode >", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeGreaterThanOrEqualTo(String value) {
            addCriterion("VendorCode >=", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLessThan(String value) {
            addCriterion("VendorCode <", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLessThanOrEqualTo(String value) {
            addCriterion("VendorCode <=", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLike(String value) {
            addCriterion("VendorCode like", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotLike(String value) {
            addCriterion("VendorCode not like", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIn(List<String> values) {
            addCriterion("VendorCode in", values, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotIn(List<String> values) {
            addCriterion("VendorCode not in", values, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeBetween(String value1, String value2) {
            addCriterion("VendorCode between", value1, value2, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotBetween(String value1, String value2) {
            addCriterion("VendorCode not between", value1, value2, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andSiteidIsNull() {
            addCriterion("SiteID is null");
            return (Criteria) this;
        }

        public Criteria andSiteidIsNotNull() {
            addCriterion("SiteID is not null");
            return (Criteria) this;
        }

        public Criteria andSiteidEqualTo(Integer value) {
            addCriterion("SiteID =", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidNotEqualTo(Integer value) {
            addCriterion("SiteID <>", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidGreaterThan(Integer value) {
            addCriterion("SiteID >", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidGreaterThanOrEqualTo(Integer value) {
            addCriterion("SiteID >=", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidLessThan(Integer value) {
            addCriterion("SiteID <", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidLessThanOrEqualTo(Integer value) {
            addCriterion("SiteID <=", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidIn(List<Integer> values) {
            addCriterion("SiteID in", values, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidNotIn(List<Integer> values) {
            addCriterion("SiteID not in", values, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidBetween(Integer value1, Integer value2) {
            addCriterion("SiteID between", value1, value2, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidNotBetween(Integer value1, Integer value2) {
            addCriterion("SiteID not between", value1, value2, "siteid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}